
CREATE PROCEDURE sp_HangHoa_GetAll
AS
BEGIN
	select	h.id,
			h.ten as TenHangHoa,
			h.ma_hang as MaHang,
			h.ma_nhom_hang as MaNhomHang,
			h.gia_nhap as GiaNhap,
			h.ghi_chu as GhiChu,
			h.ngay_cap_nhat_cuoi as NgayCapNhatCuoi,
			n.Ten as NhomHang
	from HangHoa as h 
	inner join NhomHang as n on h.ma_nhom_hang = n.id
END
GO
